SQL Server Workload Consolidation
ثبت نشده
چکیده
Database workloads are very diverse. While most database servers are lightly loaded, larger database workloads can be resource-intensive, exhibiting high I/O rates or consuming large amounts of memory. With improvements in virtualization technology and hardware, even servers running large database workloads run well in virtual machines. Servers running Microsoft's SQL Server, among the top database server platforms in the industry today, are no exception.
منابع مشابه
Measuring Database Performance in Online Services: A Trace-Based Approach
Many large-scale online services use structured storage to persist metadata and sometimes data. The structured storage is typically provided by standard database servers such as Microsoft’s SQL Server. It is important to understand the workloads seen by these servers, both for provisioning server hardware as well as to exploit opportunities for energy savings and server consolidation. In this p...
متن کاملSQL Server 2008 Consolidation
This white paper describes how SQL Server 2008 consolidation can solve problems associated with multiple SQL servers in an organization. The paper offers several methods for consolidating applications using Microsoft SQL Server 2008 and compares those methods by linking key decision points to business requirements.
متن کاملRelational Cloud: a Database Service for the cloud
This paper introduces a new transactional “database-as-a-service” (DBaaS) called Relational Cloud. A DBaaS promises to move much of the operational burden of provisioning, configuration, scaling, performance tuning, backup, privacy, and access control from the database users to the service operator, offering lower overall costs to users. Early DBaaS efforts include Amazon RDS and Microsoft SQL ...
متن کاملServer Workload Analysis for Power Minimization using Consolidation
Server consolidation has emerged as a promising technique to reduce the energy costs of a data center. In this work, we present the first detailed analysis of an enterprise server workload from the perspective of finding characteristics for consolidation. We observe significant potential for power savings if consolidation is performed using off-peak values for application demand. However, these...
متن کاملWorkload Characterization and Capacity Planning for MS SQL Server
Microsoft SQL Server is a multi-component database management system taking advantage of many features of the underlying operating system. Obtaining a breakdown of its workload by categories such as users and applications requires a non-standard approach. This paper describes such an approach as well as architectural features of MS SQL Server relevant for workload analysis and capacity planning.
متن کامل